﻿CREATE TABLE [ODCore].[Feature] (
    [FeatureID]      INT                 IDENTITY (1, 1) NOT NULL,
    [HierarchyCode]  [sys].[hierarchyid] NOT NULL,
    [HierarchyLevel] AS                  ([HierarchyCode].[GetLevel]()),
    [FeatureName]    VARCHAR (200)       NULL,
    [FeatureTypeID]  INT                 NOT NULL,
    [GeoPosition]    [sys].[geography]   NOT NULL
);

